package com.weactivity.mapper;

import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface FileUploadMapper {


    @Insert("insert into activity_data (aid , url ,create_time) values (#{aid},#{url},Now());")
    int insert(@Param("aid")int aid,@Param("url") String url);

    @Select("select url from activity_data where aid = #{aid} ;")
    List<String> showAll(int aid);

    @Delete("delete from activity_data where aid = #{aid} and url = #{url} ;")
    int deleteByUrl(@Param("aid") int aid,@Param("url") String url);
}
